{smcl}
{com}{sf}{ul off}{txt}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\gk57526\Dropbox\TELs & Income Inequality (Michelle Lofton)\Data\Final Dataset\December 2024\OUTPUT\Income Inequality.BASE VARIABLES.12-10-2024.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res}10 Dec 2024, 14:48:16
{txt}
{com}. 
. 
. 
. 
. **** STATA PROGRAM CODE TO ANALYZE DATA FOR "DECOMPOSING RULES VERSUS DISCRETIONARY POLICY EFFECTS" PROJECT FROM EXISTING EXCEL DATABASE [TEL Paper Data Final 12_10_24.xlsx] AND SAVE AS BASE STATA DATABASE [Income Inequality Database.NEW VARIABLES.12-10-2024.dta] ***
. 
. 
. 
. 
. 
. ** FIRST IMPORT EXCEL DATABASE WITH "12_10_24" DATABASE **
. 
. import excel "C:\Users\gk57526\Dropbox\TELs & Income Inequality (Michelle Lofton)\Data\Final Dataset\December 2024\DATA\TEL Paper Data Final 12_10_24.xlsx", sheet("Data") firstrow
{res}{text}(75 vars, 1,750 obs)

{com}. 
. 
. 
. 
. 
. *** SET DATA TO PANEL STRUCTURE  ***
. 
. 
. xtset fips year, yearly
{res}
{col 1}{txt:Panel variable: }{res:fips}{txt: (strongly balanced)}
{p 1 16 2}{txt:Time variable: }{res:year}{txt:, }{res:{bind:1986}}{txt: to }{res:{bind:2020}}{p_end}
{txt}{col 10}Delta: {res}1 year
{txt}
{com}. 
. 
. 
. 
. *** ELIMINATE NEBRASKA PANEL OF OBSERVATIONS SINCE THEY HAVE A NON-PARTISAN UNICAMERAL LEGISLATURE & ARE NON-COMPARABLE SET OF OBSERVATIONS RELATIVE TO ALL OTHER STATES **
. 
. drop if fips==31 
{txt}(35 observations deleted)

{com}. 
. 
. 
. 
. 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. 
. 
. 
.  
.  
.  
. *** GENERATE MULTI-VALUED TREATMENT INDICATOR VARIABLES FROM EXISTING TEL & PARTISAN CONTROL OF GOVERNMENT DATABASE ***
. 
. 
. 
. ** POLICYTREAT_1: TEL/NO TEL BINARY INDICATOR **
. 
. generate policytreat_1 =  1 if TEL_BI==1
{txt}(746 missing values generated)

{com}. replace  policytreat_1 =  0 if TEL_BI==0
{txt}(746 real changes made)

{com}. *
. *
. *
. tab policytreat_1

{txt}policytreat {c |}
         _1 {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}        746       43.50       43.50
{txt}          1 {c |}{res}        969       56.50      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}      1,715      100.00
{txt}
{com}. 
. 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. 
. 
. 
. ** POLICYTREAT_2: UNIFIED DEMOCRATIC PARTISAN CONTROL/UNIFIED REPUBLICAN PARTISAN CONTROL/DIVIDED PARTISAN CONTROL THREE-CATEGORY INDICATOR **
. 
. generate policytreat_2 =  1 if demgov==1 & uhdmaj==1 & lhdmaj==1
{txt}(1,316 missing values generated)

{com}. replace  policytreat_2 =  2 if repgov==1 & uhrmaj==1 & lhrmaj==1
{txt}(455 real changes made)

{com}. replace  policytreat_2 =  0 if policytreat_2==. 
{txt}(861 real changes made)

{com}. *
. *
. *
. tab policytreat_2

{txt}policytreat {c |}
         _2 {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}        861       50.20       50.20
{txt}          1 {c |}{res}        399       23.27       73.47
{txt}          2 {c |}{res}        455       26.53      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}      1,715      100.00
{txt}
{com}. 
. 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. 
. 
. ** POLICYTREAT_3: TEL/NO TEL & UNIFIED DEMOCRATIC PARTISAN CONTROL/UNIFIED REPUBLICAN PARTISAN CONTROL/DIVIDED PARTISAN CONTROL COMBINATION SIX-CATEGORY INDICATOR **
. 
. 
. 
. * PRESENCE OF TEL-BI UNDER UNIFIED DEMOCRATIC PARTISAN CONTROL OF GOVENRMENT *
. *
. generate unified_dem_tel_bi = 1 if TEL_BI==1 & policytreat_2==1
{txt}(1,489 missing values generated)

{com}. *
. replace  unified_dem_tel_bi = 0 if unified_dem_tel_bi==.
{txt}(1,489 real changes made)

{com}. 
. 
. * ABSENCE OF TEL-BI UNDER UNIFIED DEMOCRATIC PARTISAN CONTROL OF GOVENRMENT *
. *
. generate unified_dem_notel_bi = 1 if TEL_BI==0 & policytreat_2==1
{txt}(1,542 missing values generated)

{com}. *
. replace  unified_dem_notel_bi = 0 if unified_dem_notel_bi==.
{txt}(1,542 real changes made)

{com}. 
. 
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. 
. * PRESENCE OF TEL-BI UNDER UNIFIED REPUBLICAN PARTISAN CONTROL OF GOVENRMENT *
. *
. generate unified_rep_tel_bi = 1 if TEL_BI==1 & policytreat_2==2
{txt}(1,453 missing values generated)

{com}. *
. replace  unified_rep_tel_bi = 0 if unified_rep_tel_bi==.
{txt}(1,453 real changes made)

{com}. 
. 
. 
. * ABSENCE OF TEL-BI UNDER UNIFIED REPUBLICAN PARTISAN CONTROL OF GOVENRMENT *
. *
. generate unified_rep_notel_bi = 1 if TEL_BI==0 & policytreat_2==2
{txt}(1,522 missing values generated)

{com}. *
. replace  unified_rep_notel_bi = 0 if unified_rep_notel_bi==.
{txt}(1,522 real changes made)

{com}. 
. 
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. 
. 
. * PRESENCE OF TEL-BI UNDER DIVIDED PARTISAN CONTROL OF GOVENRMENT *
. *
. generate dpc_tel_bi = 1 if TEL_BI==1 & policytreat_2==0
{txt}(1,234 missing values generated)

{com}. *
. replace  dpc_tel_bi = 0 if dpc_tel_bi==.
{txt}(1,234 real changes made)

{com}. 
. 
. 
. * ABSENCE OF TEL-BI UNDER DIVIDED PARTISAN CONTROL OF GOVENRMENT *
. *
. generate dpc_notel_bi = 1 if TEL_BI==0 & policytreat_2==0
{txt}(1,335 missing values generated)

{com}. *
. replace  dpc_notel_bi = 0 if dpc_notel_bi==.
{txt}(1,335 real changes made)

{com}. 
. *
. *
. *
. 
. tab  unified_dem_tel_bi

{txt}unified_dem {c |}
    _tel_bi {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}      1,489       86.82       86.82
{txt}          1 {c |}{res}        226       13.18      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}      1,715      100.00
{txt}
{com}. tab  unified_dem_notel_bi

{txt}unified_dem {c |}
  _notel_bi {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}      1,542       89.91       89.91
{txt}          1 {c |}{res}        173       10.09      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}      1,715      100.00
{txt}
{com}. *
. tab unified_rep_tel_bi

{txt}unified_rep {c |}
    _tel_bi {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}      1,453       84.72       84.72
{txt}          1 {c |}{res}        262       15.28      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}      1,715      100.00
{txt}
{com}. tab unified_rep_notel_bi

{txt}unified_rep {c |}
  _notel_bi {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}      1,522       88.75       88.75
{txt}          1 {c |}{res}        193       11.25      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}      1,715      100.00
{txt}
{com}. *
. tab  dpc_tel_bi  

 {txt}dpc_tel_bi {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}      1,234       71.95       71.95
{txt}          1 {c |}{res}        481       28.05      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}      1,715      100.00
{txt}
{com}. tab  dpc_notel_bi

{txt}dpc_notel_b {c |}
          i {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}      1,335       77.84       77.84
{txt}          1 {c |}{res}        380       22.16      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}      1,715      100.00
{txt}
{com}. 
. 
. 
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. 
. 
. ** GENERATE MULTIVALUED TREATMENT INDICATOR VARIABLE [BASELINE CATEGORY: DIVIDED PARTISAN CONTROL IN ABSENCE OF TEL (policytreat_3 = 0)] **
. 
. generate policytreat_3 = 2 if  unified_dem_notel_bi==1
{txt}(1,542 missing values generated)

{com}. *
. replace  policytreat_3 = 3 if  unified_dem_tel_bi==1
{txt}(226 real changes made)

{com}. *
. *
. replace  policytreat_3 = 4 if  unified_rep_notel_bi==1
{txt}(193 real changes made)

{com}. *
. replace  policytreat_3 = 5 if  unified_rep_tel_bi==1
{txt}(262 real changes made)

{com}. *
. *
. replace  policytreat_3 = 0 if  dpc_notel_bi==1
{txt}(380 real changes made)

{com}. *
. replace  policytreat_3 = 1 if  dpc_tel_bi==1
{txt}(481 real changes made)

{com}. 
. *
. *
. *
. 
. tab policytreat_3

{txt}policytreat {c |}
         _3 {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}        380       22.16       22.16
{txt}          1 {c |}{res}        481       28.05       50.20
{txt}          2 {c |}{res}        173       10.09       60.29
{txt}          3 {c |}{res}        226       13.18       73.47
{txt}          4 {c |}{res}        193       11.25       84.72
{txt}          5 {c |}{res}        262       15.28      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}      1,715      100.00
{txt}
{com}. 
. *
. *
. *
. 
. 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. 
. 
. 
. 
. *** GENERATE WITHIN-STATE MEASURES EMPLOYED IN STATISTICAL ANALYSES *** 
. 
. 
. 
. 
. *** FIRST, CONVERT SUMMARY INCOME INEQUALITY INDICES [ATKINSON & THEIL] INTO PERCENTAGES BY MULTIPLYING BY 100 ***
. 
. gen Atkin05_pct = Atkin05*100
{txt}
{com}. *
. gen Theil_pct = Theil*100
{txt}
{com}. *
. *
. *
. gen Gini_pct = Gini*100
{txt}
{com}. *
. gen RMeanDev_pct = RMeanDev*100
{txt}
{com}. 
. 
. 
. ************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************
. 
. 
. 
. ** 1. OUTCOME VARIABLES: SUMMARY MEASURES OF INCOME INEQUALITY [MEASURES ANALYZED IN THIS STUDY ARE THOSE WITH BOTH TRANSFER PROPERTIES & DECOMPOSABLE -- UNLIKE GINI COEFFICIENTS & RELATIVE MEAN DEVIATION MEASURES WHICH VIOLATE ONE OR BOTH OF THESE PROPERTIES] **
. 
. 
. 
. 
. * 1A. ATKINSON INEQUALITY INDEX [DECOMPOSABLE & STATISFIES WEAK TRANSFERS PRINCIPLE] *  
. 
. * calculate the state group-means *
. egen bAtkin05_pct = mean(Atkin05_pct), by(fips)
{txt}
{com}. *
. * compute the within-state deviations from the state group means *
. gen wAtkin05_pct = Atkin05_pct - bAtkin05_pct
{txt}
{com}. *
. * compute descriptive statistics & correlation for overall measure and within-state group mean measure *
. sum Atkin05_pct  wAtkin05_pct, detail

                         {txt}Atkin05_pct
{hline 61}
      Percentiles      Smallest
 1%    {res} 19.80519       18.60228
{txt} 5%    {res} 21.19871       18.66061
{txt}10%    {res} 22.08113       18.70834       {txt}Obs         {res}      1,715
{txt}25%    {res} 23.72811       18.92256       {txt}Sum of wgt. {res}      1,715

{txt}50%    {res} 26.23995                      {txt}Mean          {res} 26.70503
                        {txt}Largest       Std. dev.     {res} 4.021655
{txt}75%    {res} 28.70548       40.62101
{txt}90%    {res} 32.12663       40.62716       {txt}Variance      {res} 16.17371
{txt}95%    {res} 34.88338       40.83274       {txt}Skewness      {res} .8469676
{txt}99%    {res} 38.78087       41.08131       {txt}Kurtosis      {res}  3.79188

                        {txt}wAtkin05_pct
{hline 61}
      Percentiles      Smallest
 1%    {res}-7.476707      -11.39835
{txt} 5%    {res}-4.950455      -9.909086
{txt}10%    {res} -3.94795      -9.774218       {txt}Obs         {res}      1,715
{txt}25%    {res}-2.277403      -9.571323       {txt}Sum of wgt. {res}      1,715

{txt}50%    {res} .4138241                      {txt}Mean          {res} 1.16e-07
                        {txt}Largest       Std. dev.     {res} 2.949254
{txt}75%    {res} 2.146595       6.993366
{txt}90%    {res}  3.39155        8.13962       {txt}Variance      {res} 8.698101
{txt}95%    {res} 4.304935       8.594379       {txt}Skewness      {res} -.383653
{txt}99%    {res} 5.815088       9.597828       {txt}Kurtosis      {res} 2.880395
{txt}
{com}. *
. correlate Atkin05_pct  wAtkin05_pct
{txt}(obs=1,715)

             {c |} Atkin0~t wAtkin~t
{hline 13}{c +}{hline 18}
 Atkin05_pct {c |}{res}   1.0000
{txt}wAtkin05_pct {c |}{res}   0.7333   1.0000

{txt}
{com}. *
. *
. *
. 
. * 1B. THEIL ENTROPY INDEX [DECOMPOSABLE & STATISFIES STRONG TRANSFERS PRINCIPLE] *
. 
. * calculate the state group-means *
. egen bTheil_pct = mean(Theil_pct), by(fips)
{txt}
{com}. *
. * compute the within-state deviations from the state group means *
. gen wTheil_pct = Theil_pct - bTheil_pct
{txt}
{com}. *
. * compute descriptive statistics & correlation for overall measure and within-state group mean measure *
. sum Theil_pct  wTheil_pct, detail

                          {txt}Theil_pct
{hline 61}
      Percentiles      Smallest
 1%    {res} 36.86203       29.44726
{txt} 5%    {res} 51.11276       29.82319
{txt}10%    {res} 56.47344       30.48318       {txt}Obs         {res}      1,715
{txt}25%    {res} 63.89604       30.98307       {txt}Sum of wgt. {res}      1,715

{txt}50%    {res} 73.09528                      {txt}Mean          {res} 76.78864
                        {txt}Largest       Std. dev.     {res} 20.16378
{txt}75%    {res}  84.9613       149.5532
{txt}90%    {res} 104.0779       149.8469       {txt}Variance      {res}  406.578
{txt}95%    {res} 118.7672       154.8079       {txt}Skewness      {res}   1.0464
{txt}99%    {res} 139.6214       165.4173       {txt}Kurtosis      {res} 4.597011

                         {txt}wTheil_pct
{hline 61}
      Percentiles      Smallest
 1%    {res}-35.73901      -70.32573
{txt} 5%    {res}-24.79498      -65.53864
{txt}10%    {res}-15.98754       -53.9603       {txt}Obs         {res}      1,715
{txt}25%    {res}-7.358875      -47.55398       {txt}Sum of wgt. {res}      1,715

{txt}50%    {res} .7469254                      {txt}Mean          {res} 5.46e-07
                        {txt}Largest       Std. dev.     {res} 13.15858
{txt}75%    {res} 8.273369       40.59401
{txt}90%    {res} 14.90852       42.58104       {txt}Variance      {res} 173.1483
{txt}95%    {res} 19.48347       46.83132       {txt}Skewness      {res}-.4818446
{txt}99%    {res} 29.59613       58.55624       {txt}Kurtosis      {res} 4.669555
{txt}
{com}. *
. correlate Theil_pct  wTheil_pct
{txt}(obs=1,715)

             {c |} Theil_~t wTheil~t
{hline 13}{c +}{hline 18}
   Theil_pct {c |}{res}   1.0000
  {txt}wTheil_pct {c |}{res}   0.6526   1.0000

{txt}
{com}. *
. *
. *
. 
. 
. 
. * 1C. GINI COEFFICIENT INEQUALITY INDEX [NON-DECOMPOSABLE & DOES NOT STATISFY WEAK NOR STRONG TRANSFERS PRINCIPLE] *  
. 
. * calculate the state group-means *
. egen bGini_pct = mean(Gini_pct), by(fips)
{txt}
{com}. *
. * compute the within-state deviations from the state group means *
. gen wGini_pct = Gini_pct - bGini_pct
{txt}
{com}. *
. * compute descriptive statistics & correlation for overall measure and within-state group mean measure *
. sum Gini_pct  wGini_pct, detail

                          {txt}Gini_pct
{hline 61}
      Percentiles      Smallest
 1%    {res} 49.79358       47.87794
{txt} 5%    {res}  52.9381       48.28015
{txt}10%    {res} 53.96984       48.73211       {txt}Obs         {res}      1,715
{txt}25%    {res}  55.7471       48.80996       {txt}Sum of wgt. {res}      1,715

{txt}50%    {res} 58.11257                      {txt}Mean          {res} 58.53357
                        {txt}Largest       Std. dev.     {res}  4.02239
{txt}75%    {res} 60.77489       71.14417
{txt}90%    {res} 63.91942       71.99874       {txt}Variance      {res} 16.17962
{txt}95%    {res} 66.46038       73.11617       {txt}Skewness      {res}  .576312
{txt}99%    {res} 69.73499        73.2708       {txt}Kurtosis      {res} 3.499745

                          {txt}wGini_pct
{hline 61}
      Percentiles      Smallest
 1%    {res}-7.727886      -11.55054
{txt} 5%    {res}-4.945068      -10.77634
{txt}10%    {res}-3.498394       -10.4881       {txt}Obs         {res}      1,715
{txt}25%    {res}-2.093987      -9.897892       {txt}Sum of wgt. {res}      1,715

{txt}50%    {res}-.2480812                      {txt}Mean          {res}-4.00e-08
                        {txt}Largest       Std. dev.     {res} 3.141397
{txt}75%    {res} 2.220875       10.46047
{txt}90%    {res} 3.910568       10.46473       {txt}Variance      {res} 9.868376
{txt}95%    {res} 5.145603       11.57512       {txt}Skewness      {res} .0147507
{txt}99%    {res} 7.165089       11.71536       {txt}Kurtosis      {res} 3.379451
{txt}
{com}. *
. correlate Gini_pct  wGini_pct
{txt}(obs=1,715)

             {c |} Gini_pct wGini_~t
{hline 13}{c +}{hline 18}
    Gini_pct {c |}{res}   1.0000
   {txt}wGini_pct {c |}{res}   0.7810   1.0000

{txt}
{com}. *
. *
. *
. 
. 
. * 1D. REAL MEAN DEVIATION INEQUALITY INDEX [NON-DECOMPOSABLE & DOES NOT STATISFY WEAK NOR STRONG TRANSFERS PRINCIPLE] *  
. 
. * calculate the state group-means *
. egen bRMeanDev_pct = mean(RMeanDev_pct), by(fips)
{txt}
{com}. *
. * compute the within-state deviations from the state group means *
. gen wRMeanDev_pct = RMeanDev_pct - bRMeanDev_pct
{txt}
{com}. *
. * compute descriptive statistics & correlation for overall measure and within-state group mean measure *
. sum RMeanDev_pct  wRMeanDev_pct, detail

                        {txt}RMeanDev_pct
{hline 61}
      Percentiles      Smallest
 1%    {res} 71.17782       68.50664
{txt} 5%    {res} 74.07571       68.97868
{txt}10%    {res} 75.30833       69.48174       {txt}Obs         {res}      1,715
{txt}25%    {res} 78.13688       69.69261       {txt}Sum of wgt. {res}      1,715

{txt}50%    {res}   81.548                      {txt}Mean          {res} 82.13883
                        {txt}Largest       Std. dev.     {res} 5.799657
{txt}75%    {res}  85.3071       101.5273
{txt}90%    {res} 90.11438       101.6182       {txt}Variance      {res} 33.63603
{txt}95%    {res} 93.05151       102.2571       {txt}Skewness      {res} .6896945
{txt}99%    {res} 99.00193       104.6505       {txt}Kurtosis      {res} 3.546388

                        {txt}wRMeanDev_pct
{hline 61}
      Percentiles      Smallest
 1%    {res}-10.90645      -16.47522
{txt} 5%    {res}-7.302605      -16.26227
{txt}10%    {res}-5.539383      -14.55783       {txt}Obs         {res}      1,715
{txt}25%    {res}-3.402016      -14.08464       {txt}Sum of wgt. {res}      1,715

{txt}50%    {res}-.1352921                      {txt}Mean          {res}-1.38e-07
                        {txt}Largest       Std. dev.     {res} 4.458366
{txt}75%    {res} 3.529266       11.96131
{txt}90%    {res} 5.207169       13.00807       {txt}Variance      {res} 19.87702
{txt}95%    {res}   6.2957       13.95021       {txt}Skewness      {res}-.2722239
{txt}99%    {res} 8.921623       14.15978       {txt}Kurtosis      {res} 2.784841
{txt}
{com}. *
. correlate RMeanDev_pct  wRMeanDev_pct
{txt}(obs=1,715)

             {c |} RMeanD~t wRMean~t
{hline 13}{c +}{hline 18}
RMeanDev_pct {c |}{res}   1.0000
{txt}wRMeanDev_~t {c |}{res}   0.7687   1.0000

{txt}
{com}. *
. *
. 
. 
. 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. 
.  
.  
. ** 2. OUTCOME VARIABLES: AFFLUENT/"UPPER-TAIL" INCOME SHARE BASED MEASURES OF INCOME INEQUALITY **
. 
. 
. 
. 
. * 2A. TOP 10% INCOME SHARE *  
. 
. * calculate the state group-means *
. egen bTop10_adj = mean(Top10_adj), by(fips)
{txt}
{com}. *
. * compute the within-state deviations from the state group means *
. gen wTop10_adj = Top10_adj - bTop10_adj
{txt}
{com}. *
. * compute descriptive statistics & correlation for overall measure and within-state group mean measure *
. sum Top10_adj  wTop10_adj, detail

                          {txt}Top10_adj
{hline 61}
      Percentiles      Smallest
 1%    {res} 32.54723       28.50227
{txt} 5%    {res} 34.77686       28.61138
{txt}10%    {res} 36.37321       29.12889       {txt}Obs         {res}      1,715
{txt}25%    {res} 38.95992       29.34901       {txt}Sum of wgt. {res}      1,715

{txt}50%    {res} 42.09803                      {txt}Mean          {res} 42.74954
                        {txt}Largest       Std. dev.     {res} 5.569135
{txt}75%    {res} 45.94236       62.85177
{txt}90%    {res} 49.62523       63.30538       {txt}Variance      {res} 31.01526
{txt}95%    {res} 53.55463       67.25359       {txt}Skewness      {res} .7613712
{txt}99%    {res} 59.17974       69.11398       {txt}Kurtosis      {res} 4.067547

                         {txt}wTop10_adj
{hline 61}
      Percentiles      Smallest
 1%    {res} -9.39677      -12.81232
{txt} 5%    {res}-6.466705      -11.78947
{txt}10%    {res}-4.891609      -10.71653       {txt}Obs         {res}      1,715
{txt}25%    {res}-2.773018       -10.3451       {txt}Sum of wgt. {res}      1,715

{txt}50%    {res}-.0684471                      {txt}Mean          {res} 2.08e-07
                        {txt}Largest       Std. dev.     {res} 3.888856
{txt}75%    {res}   2.8536       12.34703
{txt}90%    {res}  4.75187       14.28115       {txt}Variance      {res}  15.1232
{txt}95%    {res} 5.866695       14.59273       {txt}Skewness      {res}-.0220142
{txt}99%    {res}  9.04924       16.14153       {txt}Kurtosis      {res} 3.051809
{txt}
{com}. *
. correlate Top10_adj  wTop10_adj
{txt}(obs=1,715)

             {c |} Top10_~j wTop10~j
{hline 13}{c +}{hline 18}
   Top10_adj {c |}{res}   1.0000
  {txt}wTop10_adj {c |}{res}   0.6983   1.0000

{txt}
{com}. *
. *
. *
. 
. 
. * 2B. TOP 1% INCOME SHARE *  
. 
. * calculate the state group-means *
. egen bTop1_adj = mean(Top1_adj), by(fips)
{txt}
{com}. *
. * compute the within-state deviations from the state group means *
. gen wTop1_adj = Top1_adj - bTop1_adj
{txt}
{com}. *
. * compute descriptive statistics & correlation for overall measure and within-state group mean measure *
. sum Top1_adj  wTop1_adj, detail

                          {txt}Top1_adj
{hline 61}
      Percentiles      Smallest
 1%    {res} 9.369864       7.612396
{txt} 5%    {res} 10.71517       8.205978
{txt}10%    {res} 11.59316       8.254523       {txt}Obs         {res}      1,715
{txt}25%    {res}  13.1635       8.327889       {txt}Sum of wgt. {res}      1,715

{txt}50%    {res} 15.45788                      {txt}Mean          {res} 16.27342
                        {txt}Largest       Std. dev.     {res} 4.604928
{txt}75%    {res} 17.93192        35.3031
{txt}90%    {res} 22.14015       36.06892       {txt}Variance      {res} 21.20536
{txt}95%    {res} 25.94893       36.38235       {txt}Skewness      {res} 1.437864
{txt}99%    {res} 32.09391       37.39271       {txt}Kurtosis      {res} 5.591785

                          {txt}wTop1_adj
{hline 61}
      Percentiles      Smallest
 1%    {res}-7.924736       -13.8577
{txt} 5%    {res}-4.555777      -11.67083
{txt}10%    {res}-3.529479      -11.01802       {txt}Obs         {res}      1,715
{txt}25%    {res}-1.938137      -10.09088       {txt}Sum of wgt. {res}      1,715

{txt}50%    {res} .1664162                      {txt}Mean          {res}-6.15e-09
                        {txt}Largest       Std. dev.     {res} 2.991833
{txt}75%    {res} 1.726088       10.86249
{txt}90%    {res} 3.555149        11.1592       {txt}Variance      {res} 8.951066
{txt}95%    {res} 4.708113       12.74193       {txt}Skewness      {res}-.0159186
{txt}99%    {res} 7.834017       13.59899       {txt}Kurtosis      {res} 4.401084
{txt}
{com}. *
. correlate Top1_adj  wTop1_adj
{txt}(obs=1,715)

             {c |} Top1_adj wTop1_~j
{hline 13}{c +}{hline 18}
    Top1_adj {c |}{res}   1.0000
   {txt}wTop1_adj {c |}{res}   0.6497   1.0000

{txt}
{com}. *
. *
. *
. *
. 
. 
. * 2C. TOP 0.1% INCOME SHARE [APPENDIX C] *  
. 
. * calculate the state group-means *
. egen bTop01_adj = mean(Top01_adj), by(fips)
{txt}
{com}. *
. * compute the within-state deviations from the state group means *
. gen wTop01_adj = Top01_adj - bTop01_adj
{txt}
{com}. *
. * compute descriptive statistics & correlation for overall measure and within-state group mean measure *
. sum Top01_adj  wTop01_adj, detail

                          {txt}Top01_adj
{hline 61}
      Percentiles      Smallest
 1%    {res} 3.079463       2.375974
{txt} 5%    {res} 3.828436       2.603428
{txt}10%    {res} 4.292761       2.635028       {txt}Obs         {res}      1,715
{txt}25%    {res} 5.192739        2.67643       {txt}Sum of wgt. {res}      1,715

{txt}50%    {res} 6.582188                      {txt}Mean          {res}  7.29812
                        {txt}Largest       Std. dev.     {res} 3.196452
{txt}75%    {res} 8.322945       22.37995
{txt}90%    {res} 11.50152       22.45715       {txt}Variance      {res}  10.2173
{txt}95%    {res} 14.15022       23.37292       {txt}Skewness      {res} 1.789951
{txt}99%    {res} 18.87023       24.79641       {txt}Kurtosis      {res} 7.065522

                         {txt}wTop01_adj
{hline 61}
      Percentiles      Smallest
 1%    {res}-5.851357      -10.77646
{txt} 5%    {res}-3.012308      -9.275896
{txt}10%    {res}-2.243416      -9.135381       {txt}Obs         {res}      1,715
{txt}25%    {res} -1.26719      -7.584997       {txt}Sum of wgt. {res}      1,715

{txt}50%    {res}-.0519082                      {txt}Mean          {res} 1.37e-08
                        {txt}Largest       Std. dev.     {res} 2.091808
{txt}75%    {res} 1.121598       9.289524
{txt}90%    {res} 2.393208       9.531089       {txt}Variance      {res} 4.375659
{txt}95%    {res} 3.314284       9.705166       {txt}Skewness      {res} .1966394
{txt}99%    {res} 5.703447       11.12865       {txt}Kurtosis      {res} 5.843517
{txt}
{com}. *
. correlate Top01_adj  wTop01_adj
{txt}(obs=1,715)

             {c |} Top01_~j wTop01~j
{hline 13}{c +}{hline 18}
   Top01_adj {c |}{res}   1.0000
  {txt}wTop01_adj {c |}{res}   0.6544   1.0000

{txt}
{com}. *
. *
. *
. 
. * 2D. TOP 0.01% INCOME SHARE [APPENDIX C] *
. 
. * calculate the state group-means *
. egen bTop001_adj = mean(Top001_adj), by(fips)
{txt}
{com}. *
. * compute the within-state deviations from the state group means *
. gen wTop001_adj = Top001_adj - bTop001_adj
{txt}
{com}. *
. * compute descriptive statistics & correlation for overall measure and within-state group mean measure *
. sum Top001_adj  wTop001_adj, detail

                         {txt}Top001_adj
{hline 61}
      Percentiles      Smallest
 1%    {res} 1.016994       .7464185
{txt} 5%    {res} 1.331023       .8264559
{txt}10%    {res} 1.554954       .8316988       {txt}Obs         {res}      1,715
{txt}25%    {res} 2.021635        .837554       {txt}Sum of wgt. {res}      1,715

{txt}50%    {res} 2.751778                      {txt}Mean          {res} 3.253637
                        {txt}Largest       Std. dev.     {res} 1.984093
{txt}75%    {res} 3.738077        13.3578
{txt}90%    {res} 5.584932       14.19769       {txt}Variance      {res} 3.936625
{txt}95%    {res} 7.526228       15.15343       {txt}Skewness      {res} 2.263195
{txt}99%    {res} 11.11036       16.17831       {txt}Kurtosis      {res} 9.670598

                         {txt}wTop001_adj
{hline 61}
      Percentiles      Smallest
 1%    {res} -3.61901       -7.12072
{txt} 5%    {res}-1.737796      -6.388246
{txt}10%    {res}-1.231946      -6.375068       {txt}Obs         {res}      1,715
{txt}25%    {res}-.7067986      -4.963256       {txt}Sum of wgt. {res}      1,715

{txt}50%    {res} -.049931                      {txt}Mean          {res} 3.15e-09
                        {txt}Largest       Std. dev.     {res} 1.284093
{txt}75%    {res} .6133325       6.240043
{txt}90%    {res} 1.332578       6.485289       {txt}Variance      {res} 1.648895
{txt}95%    {res} 1.984907       7.090035       {txt}Skewness      {res} .4684565
{txt}99%    {res} 4.095478       8.114912       {txt}Kurtosis      {res} 8.241579
{txt}
{com}. *
. correlate Top001_adj  wTop001_adj
{txt}(obs=1,715)

             {c |} Top001~j wTop00~j
{hline 13}{c +}{hline 18}
  Top001_adj {c |}{res}   1.0000
 {txt}wTop001_adj {c |}{res}   0.6472   1.0000

{txt}
{com}. *
. *
. *
. 
. 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. ***********************************************************************************************************************************************************************************************************
. ***********************************************************************************************************************************************************************************************************
. *********************************************************************************************************************************************************************************************************** 
. *************************************************************************************************************************************************************************************************************
. *************************************************************************************************************************************************************************************************************
. *************************************************************************************************************************************************************************************************************
. *************************************************************************************************************************************************************************************************************
. 
. 
. 
. 
. save "C:\Users\gk57526\Dropbox\TELs & Income Inequality (Michelle Lofton)\Data\Final Dataset\December 2024\DATA\Income Inequality Database.BASE VARIABLES.12-10-2024.dta", replace
{txt}{p 0 4 2}
file {bf}
C:\Users\gk57526\Dropbox\TELs & Income Inequality (Michelle Lofton)\Data\Final Dataset\December 2024\DATA\Income Inequality Database.BASE VARIABLES.12-10-2024.dta{rm}
saved
{p_end}

{com}. 
. 
. 
. *
. *
. *
. 
. 
. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\gk57526\Dropbox\TELs & Income Inequality (Michelle Lofton)\Data\Final Dataset\December 2024\OUTPUT\Income Inequality.BASE VARIABLES.12-10-2024.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res}10 Dec 2024, 14:48:16
{txt}{.-}
{smcl}
{txt}{sf}{ul off}